home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
AOL File Library: 4,101 to 4,200
/
aol-file-protocol-4400-4101-to-4200.zip
/
AOLDLs
/
Business Management
/
ACS7_ V7.0 Mechanic's Scheduler
/
MECHANIC.exe
/
MECH-W70.EXE
/
MECHANIC.WIN
/
IMPORT.DOC
< prev
next >
Wrap
Text File
|
1994-06-27
|
19KB
|
453 lines
áá
Import Data Options:
==============
| OPTION 1: |
==============
"1⌐ 1▓ fielΣ o≥ 11▓ FielΣ ASCI╔ importó
Optioε ▒ givσ yo⌡ tw∩ nesteΣ selections║ 1▓ fielΣ o≥ 11▓ FielΣ ASCI╔ import« ì
Thσ '11▓ Fieldº selectioε i≤ ß variablσ MagniFilσ [TM▌ ASCI╔ impor⌠ feature«
T∩ usσ thi≤ Variablσ 11▓ FielΣ ASCI╔ impor⌠ feature¼ yo⌡ mus⌠ ente≥ thσ tota∞ ì
numbe≥ oµ field≤ cominτ in« Thσ firs⌠ 1▓ g∩ int∩ thσ maiε persoε file¼ whilσ ì
thσ res⌠ linδ int∩ MagniFilσ [TM]¼ thougΦ yo⌡ arσ no⌠ requireΣ t∩ avai∞ ì
yourselµ oµ al∞ 11▓ fields«
Iµ yo⌡ wisΦ t∩ usσ thσ variablσ MagniFilσ [TM▌ ASCI╔ impor⌠ g∩ t∩ thσ Maiε ì
Prograφ Menu¼ selec⌠ optioε 1« Afte≥ havinτ donσ that¼ ente≥ 'Gº fo≥ thσ Ge⌠ ì
screen« Oncσ there¼ ente≥ 'F2º fo≥ thσ MagniFilσ [TM▌ Menu¼ theε reaΣ thσ ì
MagniFilσ [TM▌ Hel≡ screeε b∙ enterinτ 'H'.
Impor⌠ datß froφ ASCI╔ file:
áááCreatσ aε ASCI╔ "commß delimitedó filσ witΦ thesσ 12 fields:
áááFirs⌠ namσ <=╜ u≡ t∩ 2░ characters
áááLas⌠ namσ <=╜ u≡ t∩ 2░ characters
áááCompan∙ namσ <=╜ u≡ t∩ 4░ characters
áááAddres≤ ▒ <=╜ u≡ t∩ 3░ characters¼ firs⌠ linσ oµ addres≤
áááAddres≤ ▓á <=╜ u≡ t∩ 3░ characters¼á2nΣ line¼áiµ any¼ásucΦáa≤
ááá'Suitσ 214'
áááCit∙ <=╜ u≡ t∩ 3░ characters
áááStatσ <=╜ tw∩ characte≥ state¼ iµ U.S.A.╗ elsσ leavσ blank
áááZi≡ <=╜ U.S.A« Zi≡ code¼ ╡ characters
áááZi≡4 <=╜ U.S.A« Supplemental Zi≡ code¼ 4 characters
áááPhonσ <=╜ 1│ character¼ iµ .U.S.A« o≥ Canada« Mus⌠ be
in this form: (214)690-6017
Observe character 1 is '(', 5 is ')', and 9 is '-'
áááComment1 <== any comment, up to 60 characters
Sex ID <== if used, such as 'Dr.', 'Captain', or 'Reverend'
Optioε 1 wil∞ impor⌠ froφ aε ASCI╔ filσ named║ 'AIMPORT.TXT'« Makσ surσ tha⌠ ì
you≥ filσ ha≤ tha⌠ name.
Observσ belo≈ onσ recorΣ iε thσ ASCI╔ "commß delimitedó format:
"John D.","Cauble, Jr.","Accounting & Tax Service","11056 Shady Trail",
"Suite 101","Dallas","TX","75229","0234","(214)357-5454","SIC=4303",""
Observσ tha⌠ "Suitσ 101ó woulΣ normall∙ follo≈ afte≥ "1105╢ Shad∙ Trailó oε ìèonσ continuou≤ line« Herσ thσ recorΣ i≤ brokeε int∩ tw∩ line≤ onl∙ fo≥ ì
purpose≤ oµ showinτ yo⌡ ho≈ i⌠ looks.
==============
| OPTION 2: |
==============
Import data from ASCII file:
Creatσ aε ASCI╔ "commß delimitedó filσ witΦ thesσ 1│ fields:
áááFirs⌠ namσ <=╜ u≡ t∩ 2░ characters
áááLas⌠ namσ <=╜ u≡ t∩ 2░ characters
áááCompan∙ namσ <=╜ u≡ t∩ 4░ characters
áááAddres≤ ▒ <=╜ u≡ t∩ 3░ characters¼ firs⌠ linσ oµ addres≤
áááAddres≤ ▓á <=╜ u≡ t∩ 3░ characters¼á2nΣ line¼áiµ any¼ásucΦáa≤
ááá'Suitσ 214'
áááCit∙ <=╜ u≡ t∩ 3░ characters
áááStatσ <=╜ tw∩ characte≥ state¼ iµ U.S.A.╗ elsσ leavσ blank
áááZi≡ <=╜ U.S.A« Zi≡ code¼ ╡ characters
áááZi≡4 <=╜ U.S.A« Supplemental Zi≡ code¼ 4 characters
áááPhonσ <=╜ 1│ character¼ iµ .U.S.A« o≥ Canada« Mus⌠ be
in this form: (214)690-6017
Observe character 1 is '(', 5 is ')', and 9 is '-'
áááComment1 <== any comment, up to 60 characters
Sex ID <== if used, such as 'Dr.', 'Captain', or 'Reverend'
Revenue/Expense<== Any value entered here will cause a corresponding
first record in the Activity file to be created.
Optioε 2 wil∞ impor⌠ froφ aε ASCI╔ filσ named║ 'AIMPORT.TXT'« Makσ surσ tha⌠ ì
you≥ filσ ha≤ tha⌠ name«
Observσ belo≈ onσ recorΣ iε thσ ASCI╔ "commß delimitedó format:
"John D.","Cauble, Jr.","Accounting & Tax Service","11056 Shady Trail",
"Suite 101","Dallas","TX","75229","0234","(214)357-5454",
"SIC=4303","Mr.","5412.43"
Observσ tha⌠ "Suitσ 101ó woulΣ normall∙ follo≈ afte≥ "1105╢ Shad∙ Trailó oε ì
onσ continuou≤ line« Herσ thσ recorΣ i≤ brokeε int∩ tw∩ line≤ onl∙ fo≥ ì
purpose≤ oµ showinτ yo⌡ ho≈ i⌠ looks« Yo⌡ arσ no⌠ requireΣ t∩ ente≥ ß valuσ ì
fo≥ thσ Revenue/Expensσ field« Iµ yo⌡ do¼ theε thσ prograφ wil∞ creatσ ß ì
correspondinτ recorΣ iε thσ activit∙ file«
Onσ applicatioε oµ thi≤ woulΣ bσ iµ yo⌡ arσ bringinτ iε record≤ froφ aε ì
Account≤ Receivablσ file¼ witΦ aε amoun⌠ oweΣ fo≥ eacΦ debtor«
è
==============
ⁿ OPTIO╬ 3║ |
==============
Import data from ASCII file:
Creatσ aε ASCI╔ "commß delimitedó filσ witΦ thesσ 24 fields:
[Bring data into the Detail File]
áááFirs⌠ namσ <=╜ u≡ t∩ 2░ characters
áááLas⌠ namσ <=╜ u≡ t∩ 2░ characters
áááCompan∙ namσ <=╜ u≡ t∩ 4░ characters
áááAddres≤ ▒ <=╜ u≡ t∩ 3░ characters¼ firs⌠ linσ oµ addres≤
áááAddres≤ ▓á <=╜ u≡ t∩ 3░ characters¼á2nΣ line¼áiµ any¼ásucΦáa≤
ááá'Suitσ 214'
áááCit∙ <=╜ u≡ t∩ 3░ characters
áááStatσ <=╜ tw∩ characte≥ state¼ iµ U.S.A.╗ elsσ leavσ blank
áááZi≡ <=╜ U.S.A« Zi≡ code¼ ╡ characters
áááZi≡4 <=╜ U.S.A« Supplemental Zi≡ code¼ 4 characters
áááPhonσ <=╜ 1│ character¼ iµ .U.S.A« o≥ Canada« Mus⌠ be
in this form: (214)690-6017
Observe character 1 is '(', 5 is ')', and 9 is '-'
áááComment1 <== any comment, up to 60 characters
Sex ID <== if used, such as 'Dr.', 'Captain', or 'Reverend'
Detail 1 <== up to 20 characters, placed into the Detail File,
field one.
Detail 2 <== up to 20 characters
Detail 3 <== up to 20 characters
Detail 4 <== up to 20 characters
Detail 5 <== up to 20 characters
Detail 6 <== up to 20 characters
Detail 7 <== up to 20 characters
Detail 8 <== up to 20 characters
Detail 9 <== up to 20 characters
Detail 10 <== up to 20 characters
Detail 11 <== up to 20 characters
Detail 12 <== up to 20 characters
Optioε 3 wil∞ impor⌠ froφ aε ASCI╔ filσ named║ 'AIMPORT.TXT'« Makσ surσ tha⌠ ì
you≥ filσ ha≤ tha⌠ name.
Observσ belo≈ onσ recorΣ iε thσ ASCI╔ "commß delimitedó format:
"Alyce","Fisher","P.O. BOX","2116 E. Arapaho","P.O. Box 3823","Richardson",
"TX","75081","0433","(214)783-8581",
"they currently have an 8bit system, written in compiled",
"Mr.","DET1","DET2","DET3","DET4","DET5","DET6","DET7","DET8",
"DET9","DET10","DET11","DET12"
Observσ tha⌠ thi≤ recorΣ woulΣ normall∙ bσ oε onσ continuou≤ line¼á bu⌠á i≤ ìèherσ brokeε int∩ fivσ line≤ onl∙ fo≥ purpose≤ oµ showinτ yo⌡ ho≈ i⌠ looks.
==============
ⁿ OPTIO╬ 4║ |
==============
"4) Dun's [TM] ASCII import"
Dun'≤ Marketinτ Service≤ [TM▌ offer≤ aε outstandinτ databasσ inquir∙ servicσ ì
fo≥ sale≤ anΣ marketinτ professional≤ calleΣ Dun'≤ Direc⌠ Acces≤ [TM]« Fo≥ ì
morσ informatioε oε thei≥ offerings¼ pleasσ call:
Dun'≤ Marketinτ Services
Threσ Sylvaε Way
Parsippany¼ N╩ 0705┤ -3896
(800)624-5669
(201)605-642┤
Iµ yo⌡ havσ an∙ question≤ abou⌠ Dun'≤ Translato≥ o≥ havσ technica∞ questions¼ ì
pleasσ cal∞ thσ Duε ª Bradstree⌠ Custome≥ Suppor⌠ Cente≥ a⌠ 1-800-526-4590.
(201-464-780│ iε Ne≈ Jersey).
Thσ followinτ filσ format≤ arσ availablσ withiε Dun'≤ Direc⌠ Access¼ Versioε ì
3.0:
192 - Dun's Mailing Record
204 - Personalized DDM - One Name
260 - Dun's Telemarketing File
560 - Dun's Market Identifiers (DMI)
576 - Dun's Market Identifiers - Personalized
616 - Dun's Market Identifiers w/Trends Enhanced
706 - Dun's Market Identifiers w/AOS Enhanced
1129 - Enhanced Dun's Market Identifiers (EDMI)
1181 - EDMI Personalized Name
1331 - Enhanced Dun's Market Identifiers Plus
1383 - EDMI Plus Personalized Name
1782 - Dun's Executive Marketing Summaries (DEMS)
3062 - Dun's Executive Marketing Summaries (DEMS)
1918 - Dun's Executive Marketing Summaries (DEMS)
501 - International Dun's Market Identifiers
450 - Million Dollar File
450 - Metalworking File
536 - Asset Based Lending Master File
295 - Asset Based Lending Filings File
141 - Asset Based Lending Filings File
178 - Trinc Mailing File
266 - Trinc Mailing File è375 - Trinc Owner & User File
447 - Trinc File w/Personalization
589 - Trinc Full File
139 - Erisa Red (Pension Plans)
210 - Erisa Red (Pension Plans)
530 - Erisa Selling File
245 - Keogh
200 - MAP File
215 - MAP File
332 - MAP File
201 - UCC Mailing Label Record file
768 - UCC 768 file
640 - UCC Construction Equipment
640 - UCC Standard Office Products
768 - UCC Standard Office Products
840 - UCC 840 file
830 - UCC 830 Office Products file
522 - Metalworking - Personalized
660 - International Corporate Affiliations
530 - Broker's Ally
T∩ impor⌠ datß int∩ thi≤ program¼á pleasσ selec⌠ thσ 57╢ characte≥ StandarΣ ì
DM╔ record:
576 - Dun's Market Identifiers - Personalized
Dun'≤ [TM▌ output≤ it≤ field≤ iε thi≤ form:
1.DUNS Number
2.Business Name
3.Secondary Trade Name
4.Street Address
5.City
6.State
7.Physical Zip Code
8.Mailing Address
9.Mailing City
10.Mailing State
11.Mailing Zip Code
12.Carrier Route Code
13.Package Level Code
14.Geo Codes D&B/FIPS
15.National Code
16.State Code
17.County Code
18.City Code/MSA Code
19.SMSA Code
20.Telephone Area Code
21.Telephone Number
22.Full Telephone Numberè23.Full Exec Name
24.First Name
25.Middle Initial
26.Last Name
27.Suffix
28.Prefix
29.Title
30.MRC
31.Sales Volume
32.Code for EST/Range
33.Employees Total
34.Code for ACT/Range
35.Employees Here
36.Code for ACT/Range
37.Year Started
38.Status Indicator
39.Subsidiary Indicator
40.Manufacturing Indic
41.Ultimate DUNS
42.Headquarters DUNS
43.Parent DUNS
44.Headquarters City
45.Headquarters State
46.Foreign Ult. DUNS
47.Foreign Parent DUNS
48.Hierarchy Code
49.DIAS Code
50.Population Code
51.Transaction Code
52.Report Date
53.User Area
54.Record Class Type
55.Line of Business
56.SIC Code 1
57.SIC Code 2
58.SIC Code 3
59.SIC Code 4
60.SIC Code 5
61.SIC Code 6
62.NULL
63.Last Item
T∩ seσ aε actua∞ examplσ oµ thei≥ data¼ observσ 'SAMPLDUN.TXTº iε thi≤ ì
subdirectory« A≤ yo⌡ exi⌠ thi≤ program¼ pleasσ invoke:
LIS╘ SAMPLDUN.TX╘ <============╜ Yo⌡ ente≥ this
ááá
Dun'≤ [TM▌ anΣ Dun'≤ Direc⌠ Acces≤ [TM▌ arσ trademark≤ oµ Thσ Duε ª
Bradstree⌠ Corporation« Al∞ samplσ datß containeΣ iε 'SAMPLDUN.TXTº i≤ ì
propert∙ oµ Thσ Duε ª Bradstree⌠ Corporation.
è
==============
ⁿ OPTIO╬ 5║ |
==============
"5) dBASE III [TM] import"
Thi≤ powerful¼ eas∙ t∩ usσ featurσ make≤ i⌠ simplσ t∩ brinτ int∩ thi≤ prograφ ì
datß file≤ oµ differen⌠ characteristic≤ anΣ fielΣ types«
Wheε firs⌠ invoked¼ optioε fivσ display≤ thi≤ screen:
=========================================================================╜
With this selection, you can import data from a dBASE III [TM] file. |
|
If you elect to continue, it requires that you have a dBASE III [TM] |
file named 'DBASE.DBF' in this subdirectory. It can contain any number
of fields, though this simple-to-use feature does not require that
you import every field contained in DBASE.DBF.
I want to continue: ['F' = no, 'T' = yes]
|
F |
|
==========================================================================
A≤ yo⌡ selec⌠ 'Yº o≥ 'T'¼ optioε ╡ theε ask≤ yo⌡ iµ yo⌡ wisΦ t∩ vie≈ thσ ì
structurσ oµ thi≤ incominτ dBAS┼ II╔ [TM▌ file« Iµ so¼ theε i⌠ ask≤ yo⌡ iµ ì
yo⌡ wan⌠ t∩ prin⌠ thσ structure«
Iε an∙ case¼ thσ prograφ theε display≤ thi≤ screen║
==========================================================================
== Field 1, field name = PHONE == |
Please enter processing code for this unmatched field. |
0 |
Unmatched fields remaining in this import session:
First name Zip
Last name Zip4
Company name Phone
Address 1 Comment1, under 60 characters
Address 2 Comment2, under 60 characters
City Title
State Sex ID
Memo [0 used] MagniFile [TM] [0 used] è
Unmatched field codes:
0 = Skip this field now
1 = First name 2 = Last name 3 = Company name 4 = Address 1
5 = Address 2 6 = City 7 = State 8 = Zip
9 = Zip4 10 = Phone 11 = Comment1 12 = Comment2
13 = Title 14 = Sex ID 15 = MagniFile 16 = Memo |
17 = Stop now, then begin process imported data. |
18 = Stop now, cease processing imported data this session. |
==========================================================================
Pleasσ observσ thσ to≡ oµ thσ screen¼ ó =╜ FielΣ 1¼ fielΣ namσ ╜ PHON┼ =="« ì
Iε thi≤ example¼ fielΣ onσ oµ thσ samplσ datß filσ i≤ 'PHONE'¼ thougΦ iε you≥ ì
actua∞ DBASE.DB╞ file¼ an∙ fielΣ namσ coulΣ occu≥ here«
A≤ yo⌡ ente≥ ß fielΣ code¼ thσ to≡ oµ thσ screeε changes¼ reflectinτ thσ namσ ì
oµ thσ curren⌠ fielΣ iε usσ iε DBASE.DBF« Thσ º UnmatcheΣ fielΣ codes refe≥ ì
t∩ thosσ field≤ withiε thi≤ prograφ wherσ optioε fivσ wil∞ attemp⌠ t∩ matcΦ ì
you≥ incominτ fields«
Internally¼ thσ prograφ i≤ keepinτ tracδ oµ code≤ ▒ througΦ 14« A≤ yo⌡ ì
ente≥ an∙ onσ oµ thesσ codes¼ thi≤ optioε wil∞ theε blocδ yo⌡ iµ yo⌡ attemp⌠ ì
t∩ ente≥ tha⌠ codσ fo≥ ß seconΣ timσ oε ß differen⌠ field.
Selectioε 15¼ MagniFile¼ allow≤ yo⌡ t∩ attacΦ u≡ t∩ 10░ incominτ field≤ anΣ ì
theε place≤ theφ behinΣ eacΦ person'≤ maiε record« EacΦ MagniFilσ fielΣ wil∞ ì
storσ u≡ t∩ 4╡ characters.
Selectioε 16¼ Memo¼ i≤ thσ mem∩ behinΣ ever∙ person'≤ record« U≡ t∩ 15,00░ ì
character≤ caε bσ importeΣ here« A≤ witΦ MagniFile¼ thσ mem∩ fielΣ allow≤ ì
yo⌡ t∩ attacΦ u≡ t∩ 10░ incominτ field≤ anΣ theε place≤ theφ behinΣ eacΦ ì
person'≤ maiε record« EacΦ importeΣ fielΣ i≤ joineΣ togethe≥ int∩ onσ ì
consecutivσ memo«
Notσ oε selectioε 10¼ Phone║
Casσ I║ seveε consecutivσ character≤ imported
Iµ yo⌡ brinτ iε seveε consecutivσ character≤ a≤ ß phonσ number¼ sucΦ a≤ ì
'6906017'¼ theε thi≤ prograφ wil∞ takσ you≥ defaul⌠ areß code¼ iµ '214'¼ ì
anΣ creatσ thi≤ entr∙ iε PHONE_1:
(214)690-6017
Case II: ten consecutivσ character≤ imported
Iµ yo⌡ brinτ iε teε consecutivσ character≤ a≤ ß phonσ number¼ sucΦ a≤ ì
'6094828279'¼ theε thi≤ prograφ wil∞ theε creatσ thi≤ entr∙ iε PHONE_1:
(609)482-8279
è Case III: Numbers or Other character width imported
Iε Casσ III¼ iµ yo⌡ brinτ iε '690-4782'¼ eigh⌠ characters¼ thσ prograφ ì
create≤ thi≤ entr∙ iε 'ReferreΣ by':
Phone=690-4782
Case IV: thirteen characters imported
In case IV, the program looks for this entry in your imported field:
(609)482-8279
Oncσ detected¼ casσ I╓ theε place≤ thi≤ valuσ int∩ PHONE_1:
(609)482-8279